/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : localhost:3306
 Source Schema         : mimc

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001

 Date: 30/10/2023 15:37:07
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for im_apply
-- ----------------------------
DROP TABLE IF EXISTS `im_apply`;
CREATE TABLE `im_apply` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `from_id` bigint(20) NOT NULL COMMENT '''用户Id''',
  `to_id` bigint(20) NOT NULL COMMENT '''好友Id''',
  `target_id` bigint(20) NOT NULL COMMENT '''目标Id''',
  `apply_type` smallint(2) DEFAULT NULL COMMENT '''申请类型1好友2群组''',
  `apply_status` smallint(3) DEFAULT NULL COMMENT '''申请状态0无1同意2拒绝3忽略''',
  `apply_source` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT '''申请来源''',
  `reason` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '''申请理由''',
  `black` tinyint(1) DEFAULT '0' COMMENT '''黑名单'' 1是 0否',
  `created_time` datetime(3) DEFAULT NULL,
  `updated_time` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of im_apply
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for im_friend
-- ----------------------------
DROP TABLE IF EXISTS `im_friend`;
CREATE TABLE `im_friend` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `from_id` bigint(20) NOT NULL COMMENT '''用户Id''',
  `to_id` bigint(20) NOT NULL COMMENT '''好友Id''',
  `remark` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '''备注''',
  `black` tinyint(1) unsigned DEFAULT '0' COMMENT '''黑名单''',
  `source` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT '''来源''',
  `created_time` datetime(3) DEFAULT NULL,
  `updated_time` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_user` (`from_id`,`to_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of im_friend
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for im_group
-- ----------------------------
DROP TABLE IF EXISTS `im_group`;
CREATE TABLE `im_group` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` datetime(3) DEFAULT NULL,
  `updated_at` datetime(3) DEFAULT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `name` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '''群组名称''',
  `notice` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '''群组公告''',
  `avatar` varchar(1000) COLLATE utf8_bin DEFAULT NULL COMMENT '''头像''',
  `master` bigint(20) unsigned DEFAULT NULL COMMENT '''群主''',
  `topic_id` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '''mimc群ID''',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_name` (`name`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `name_2` (`name`),
  KEY `idx_im_group_deleted_at` (`deleted_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of im_group
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for im_user
-- ----------------------------
DROP TABLE IF EXISTS `im_user`;
CREATE TABLE `im_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `email` varchar(191) COLLATE utf8_bin NOT NULL COMMENT '''邮箱''',
  `password` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '''密码''',
  `nickname` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '''昵称''',
  `status` smallint(1) DEFAULT '1' COMMENT '''状态'' 1正常  2禁用',
  `avatar` varchar(1000) COLLATE utf8_bin DEFAULT NULL COMMENT '头像',
  `avatar_ver` int(11) DEFAULT '0' COMMENT '头像版本',
  `gender` char(1) COLLATE utf8_bin DEFAULT '男' COMMENT '''性别1男0女''',
  `intro` varchar(200) COLLATE utf8_bin DEFAULT NULL COMMENT '''介绍''',
  `cover` varchar(200) COLLATE utf8_bin DEFAULT NULL COMMENT '''封面''',
  `chat_no` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '''米聊号''',
  `birthday` date DEFAULT NULL COMMENT '生日',
  `sign` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '个人签名',
  `lang` varchar(30) COLLATE utf8_bin DEFAULT 'en' COMMENT '当前用户使用语言',
  `created_time` datetime(3) DEFAULT NULL,
  `updated_time` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `idx_email` (`email`),
  UNIQUE KEY `chat_no` (`chat_no`),
  UNIQUE KEY `idx_chat_no` (`chat_no`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of im_user
-- ----------------------------
BEGIN;
INSERT INTO `im_user` (`user_id`, `email`, `password`, `nickname`, `status`, `avatar`, `avatar_ver`, `gender`, `intro`, `cover`, `chat_no`, `birthday`, `sign`, `lang`, `created_time`, `updated_time`) VALUES (1, '2518687673@qq.com', NULL, '张三', 1, 'http://192.168.0.103:8078/avatar/1.png', 13, '男', NULL, NULL, NULL, '2023-10-12', '奔流到海不复回', 'zh', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for order_0
-- ----------------------------
DROP TABLE IF EXISTS `order_0`;
CREATE TABLE `order_0` (
  `id` bigint(20) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `goods_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of order_0
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for order_1
-- ----------------------------
DROP TABLE IF EXISTS `order_1`;
CREATE TABLE `order_1` (
  `id` bigint(20) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `goods_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of order_1
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_admin
-- ----------------------------
DROP TABLE IF EXISTS `sys_admin`;
CREATE TABLE `sys_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `real_name` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `login_time` datetime DEFAULT NULL,
  `login_ip` varchar(20) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_admin
-- ----------------------------
BEGIN;
INSERT INTO `sys_admin` (`id`, `username`, `real_name`, `password`, `login_time`, `login_ip`, `create_time`, `update_time`) VALUES (1, 'admin', '管理员', '2d6cb0bfe6d6b955a35217a763878e78', '2023-10-30 14:35:29', '127.0.0.1', '2023-04-30 22:57:41', NULL);
INSERT INTO `sys_admin` (`id`, `username`, `real_name`, `password`, `login_time`, `login_ip`, `create_time`, `update_time`) VALUES (2, 'chozay', '韦小宝', '2d6cb0bfe6d6b955a35217a763878e78', '2023-07-17 15:16:54', '127.0.0.1', '2023-07-10 18:14:00', '2023-07-13 18:03:20');
COMMIT;

-- ----------------------------
-- Table structure for sys_app_version
-- ----------------------------
DROP TABLE IF EXISTS `sys_app_version`;
CREATE TABLE `sys_app_version` (
  `version_id` int(11) NOT NULL AUTO_INCREMENT,
  `version_name` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '版本名称',
  `version_code` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '版本号',
  `package_type` smallint(3) DEFAULT '0' COMMENT '0是整包升级（apk或者appstore或者安卓应用市场） 1是wgt升级',
  `force` tinyint(1) DEFAULT '0' COMMENT '是否强制升级 0 否 1是',
  `silence` tinyint(1) DEFAULT NULL COMMENT '是否静默更新 0代表否 1代表是',
  `platform` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '平台 android ios win',
  `download_url` varchar(500) COLLATE utf8_bin NOT NULL COMMENT '下载地址',
  `issue` tinyint(1) DEFAULT '0' COMMENT '是否发行0未发行1已发行',
  `create_time` datetime(3) DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(3) DEFAULT NULL,
  `zh` varchar(1000) COLLATE utf8_bin DEFAULT NULL COMMENT '中文',
  `en` varchar(1000) COLLATE utf8_bin DEFAULT NULL COMMENT '英文',
  `zhhant` varchar(1000) COLLATE utf8_bin DEFAULT NULL COMMENT '简体中文',
  PRIMARY KEY (`version_id`),
  UNIQUE KEY `version_name_idx` (`version_name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='APP版本控制';

-- ----------------------------
-- Records of sys_app_version
-- ----------------------------
BEGIN;
INSERT INTO `sys_app_version` (`version_id`, `version_name`, `version_code`, `package_type`, `force`, `silence`, `platform`, `download_url`, `issue`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (1, '1.0.0', '101', 0, 0, 0, 'android', 'https://cos2.appmeta.cn/c7bfbd9225629a0f0f1fc6b594b39e48d50479de.apk?sign=42feecb48caa6d32b4f678637729ec09&t=1698416117', 0, '2023-10-20 11:16:25.578', '2023-10-27 23:22:48.298', '1.修复bug\n2.增加多语言', '1.修复bug en\n2.增加多语言 en', '1.修复bug\n2.增加多语言');
INSERT INTO `sys_app_version` (`version_id`, `version_name`, `version_code`, `package_type`, `force`, `silence`, `platform`, `download_url`, `issue`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (2, '1.0.1', '101', 0, 0, 0, 'android', 'https://cos2.appmeta.cn/c7bfbd9225629a0f0f1fc6b594b39e48d50479de.apk?sign=42feecb48caa6d32b4f678637729ec09&t=1698416117', 1, '2023-10-27 23:12:03.702', '2023-10-27 23:12:03.702', '测试', '测试', '测试');
INSERT INTO `sys_app_version` (`version_id`, `version_name`, `version_code`, `package_type`, `force`, `silence`, `platform`, `download_url`, `issue`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (3, '1.0.3', '103', 0, 0, 0, 'android', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-6bef1fe3-e3e3-4909-9f0c-6ed9bd11c93b/aae2360a-6628-4c93-b873-ce1600b9a852.apk', 1, '2023-10-27 23:14:15.328', '2023-10-28 00:05:41.771', '测试', '测试', '测试');
INSERT INTO `sys_app_version` (`version_id`, `version_name`, `version_code`, `package_type`, `force`, `silence`, `platform`, `download_url`, `issue`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (4, '1.0.4', '104', 0, 0, 0, 'android', 'https://mockuphone.com/', 1, '2023-10-30 14:45:51.503', '2023-10-30 14:47:49.377', '1.新增语言管理<br>\n2.新增翻译管理<br>\n3.新增版本控制<br>\n4.新增文件管理', '1.新增语言管理<br>\n2.新增翻译管理<br>\n3.新增版本控制<br>\n4.新增文件管理', '1.新增语言管理<br>\n2.新增翻译管理<br>\n3.新增版本控制<br>\n4.新增文件管理');
COMMIT;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
  `config_id` int(5) NOT NULL AUTO_INCREMENT COMMENT '参数主键',
  `config_name` varchar(100) DEFAULT '' COMMENT '参数名称',
  `config_key` varchar(100) DEFAULT '' COMMENT '参数键名',
  `config_value` mediumtext COMMENT '参数键值',
  `config_type` char(1) DEFAULT 'N' COMMENT '系统内置（Y是 N否）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`config_id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='参数配置表';

-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1, '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', '2023-03-28 21:31:15', '', NULL, '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2, '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', '2023-03-28 21:31:15', '', NULL, '初始化密码 123456');
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (4, '账号自助-验证码开关', 'sys.account.captchaEnabled', 'true', 'Y', 'admin', '2023-03-28 21:31:15', '', NULL, '是否开启验证码功能（true开启，false关闭）');
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (5, '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 'admin', '2023-03-28 21:31:15', '', NULL, '是否开启注册用户功能（true开启，false关闭）');
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (6, '用户登录-黑名单列表', 'sys.login.blackIPList', '', 'Y', 'admin', '2023-03-28 21:31:15', '', NULL, '设置登录IP黑名单限制，多个匹配项以;分隔，支持匹配（*通配、网段）');
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (9, '邮箱域名', 'email.host', 'smtp.163.com', 'N', 'admin', '2023-10-16 21:40:57', '', NULL, '邮箱域名');
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (10, '邮箱用户', 'email.user', '', 'N', 'admin', '2023-10-16 21:42:38', '', NULL, '邮箱用户');
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (11, '邮箱密码', 'email.password', '', 'N', 'admin', '2023-10-16 21:44:15', 'admin', '2023-10-16 21:47:40', '邮箱密码');
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (12, '验证码模版', 'sms.code.template', '你的登录验证码为:%d,10分钟内有效', 'N', 'admin', '2023-10-16 21:46:29', '', NULL, '验证码模版');
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (13, '小米消息云AppId', 'mimc.appid', '', 'N', 'admin', '2023-10-16 22:38:59', '', NULL, '小米消息云AppId');
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (14, '小米消息云AppKey', 'mimc.appkey', '', 'N', 'admin', '2023-10-16 22:39:41', '', NULL, '小米消息云AppKey');
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (15, '小米消息云APPSECRET', 'mimc.appsecret', '', 'N', 'admin', '2023-10-16 22:40:31', '', NULL, '小米消息云APPSECRET');
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (16, '小米消息云REGIONKEY', 'mimc.regionkey', 'REGION_CN', 'N', 'admin', '2023-10-16 22:42:30', 'admin', '2023-10-20 09:27:52', '小米消息云REGIONKEY');
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (17, '小米消息云用户账号前缀', 'mimc.appaccount.prefix', 'michat_', 'N', 'admin', '2023-10-16 22:44:09', 'admin', '2023-10-20 09:27:47', '小米消息云用户账号前缀');
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (18, '邮箱端口号', 'email.port', '465', 'N', 'admin', '2023-10-16 23:14:21', '', NULL, '邮箱端口号');
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (19, '语言版本', 'lang.version', '143', 'N', 'admin', '2023-10-19 22:53:04', 'admin', '2023-10-20 09:27:42', '语言版本');
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (20, '默认头像地址', 'default.avatar.url', 'http://pic.imeitou.com/uploads/allimg/220707/7-220FG64123.jpg', 'N', 'admin', '2023-10-25 23:59:16', '', NULL, '默认头像地址');
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (21, '上传设置', 'upload.settings', '{\"default\":\"local\",\"engine\":{\"local\":{\"domain\":\"http://192.168.0.103:8078\"},\"minio\":{\"bucket\":\"mimc\",\"key\":\"fi7CHzfTMEAm0T99Aoiz\",\"region\":\"ap-hongkong\",\"secret\":\"XoR1Fz8DT4OfWU9c0RdMye6K9R3LZDjv8cqmc0eR\",\"domain\":\"http://127.0.0.1:9000\",\"style_domain\":\"http://192.168.0.103:9000\"}}}', 'Y', 'admin', '2023-10-28 10:46:12', 'admin', '2023-10-29 22:05:19', '上传设置');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_data`;
CREATE TABLE `sys_dict_data` (
  `dict_code` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典编码',
  `dict_sort` int(4) DEFAULT '0' COMMENT '字典排序',
  `dict_label` varchar(100) DEFAULT '' COMMENT '字典标签',
  `dict_value` varchar(100) DEFAULT '' COMMENT '字典键值',
  `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
  `css_class` varchar(100) DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
  `list_class` varchar(100) DEFAULT NULL COMMENT '表格回显样式',
  `is_default` char(1) DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_code`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COMMENT='字典数据表';

-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1, 1, '男', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '性别男');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2, 2, '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '性别女');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (3, 3, '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '性别未知');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (4, 1, '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '显示菜单');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (5, 2, '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '隐藏菜单');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (6, 1, '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '正常状态');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (7, 2, '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '停用状态');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (8, 1, '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '正常状态');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (9, 2, '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '停用状态');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (10, 1, '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '默认分组');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (11, 2, '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '系统分组');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (12, 1, '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '系统默认是');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (13, 2, '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '系统默认否');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (14, 1, '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '通知');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (15, 2, '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '公告');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (16, 1, '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '正常状态');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (17, 2, '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '关闭状态');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (18, 99, '其他', '0', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '其他操作');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (19, 1, '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '新增操作');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (20, 2, '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '修改操作');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (21, 3, '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '删除操作');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (22, 4, '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '授权操作');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (23, 5, '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '导出操作');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (24, 6, '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '导入操作');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (25, 7, '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '强退操作');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (26, 8, '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '生成操作');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (27, 9, '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '清空操作');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (28, 1, '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '正常状态');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (29, 2, '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '停用状态');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (30, 1, '所有人可见', '1', 'app_prv_type', NULL, 'primary', 'N', '0', 'admin', '2023-07-18 18:51:06', 'admin', '2023-07-18 19:08:36', '测试');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type` (
  `dict_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典主键',
  `dict_name` varchar(100) DEFAULT '' COMMENT '字典名称',
  `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_id`),
  UNIQUE KEY `dict_type` (`dict_type`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='字典类型表';

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1, '用户性别', 'sys_user_sex', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '用户性别列表');
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2, '菜单状态', 'sys_show_hide', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '菜单状态列表');
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (3, '系统开关', 'sys_normal_disable', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '系统开关列表');
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (4, '任务状态', 'sys_job_status', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '任务状态列表');
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (5, '任务分组', 'sys_job_group', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '任务分组列表');
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (6, '系统是否', 'sys_yes_no', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '系统是否列表');
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (7, '通知类型', 'sys_notice_type', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '通知类型列表');
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (8, '通知状态', 'sys_notice_status', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '通知状态列表');
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (9, '操作类型', 'sys_oper_type', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '操作类型列表');
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (10, '系统状态', 'sys_common_status', '0', 'admin', '2023-03-28 21:31:15', '', NULL, '登录状态列表');
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (12, '隐私类型', 'app_prv_type', '0', 'admin', '2023-07-18 16:42:01', 'admin', '2023-07-18 18:56:52', 'APP隐私类型1');
COMMIT;

-- ----------------------------
-- Table structure for sys_lang
-- ----------------------------
DROP TABLE IF EXISTS `sys_lang`;
CREATE TABLE `sys_lang` (
  `lang_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '语言名称',
  `var_name` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '字段名称 用小写英文',
  `back_code` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '后端代码',
  `front_code` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '前段代码',
  `remark` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '备注',
  `is_default` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否默认 1是 0否',
  `create_time` datetime(3) DEFAULT NULL,
  `update_time` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`lang_id`) USING BTREE,
  UNIQUE KEY `name` (`name`) USING BTREE COMMENT '名称唯一',
  UNIQUE KEY `var_name` (`var_name`) USING BTREE COMMENT '字段名称唯一'
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='语言分类';

-- ----------------------------
-- Records of sys_lang
-- ----------------------------
BEGIN;
INSERT INTO `sys_lang` (`lang_id`, `name`, `var_name`, `back_code`, `front_code`, `remark`, `is_default`, `create_time`, `update_time`) VALUES (1, '中文简体', 'zh', 'zh-cn', 'zh-Hans', '中文简体', 1, '2023-10-18 22:21:04.680', '2023-10-18 23:10:31.212');
INSERT INTO `sys_lang` (`lang_id`, `name`, `var_name`, `back_code`, `front_code`, `remark`, `is_default`, `create_time`, `update_time`) VALUES (2, 'English', 'en', 'en-us', 'en', 'English', 0, '2023-10-18 22:21:33.731', '2023-10-18 22:21:33.731');
INSERT INTO `sys_lang` (`lang_id`, `name`, `var_name`, `back_code`, `front_code`, `remark`, `is_default`, `create_time`, `update_time`) VALUES (4, '中文繁体', 'zhhant', 'zh-hant', 'zh-Hant', '中文繁体', 0, '2023-10-19 19:28:31.002', '2023-10-19 19:28:31.002');
COMMIT;

-- ----------------------------
-- Table structure for sys_logininfor
-- ----------------------------
DROP TABLE IF EXISTS `sys_logininfor`;
CREATE TABLE `sys_logininfor` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '访问ID',
  `user_name` varchar(50) DEFAULT '' COMMENT '用户账号',
  `ipaddr` varchar(128) DEFAULT '' COMMENT '登录IP地址',
  `login_location` varchar(255) DEFAULT '' COMMENT '登录地点',
  `browser` varchar(50) DEFAULT '' COMMENT '浏览器类型',
  `os` varchar(50) DEFAULT '' COMMENT '操作系统',
  `status` char(1) DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
  `msg` varchar(255) DEFAULT '' COMMENT '提示消息',
  `login_time` datetime DEFAULT NULL COMMENT '访问时间',
  PRIMARY KEY (`id`),
  KEY `idx_sys_logininfor_s` (`status`),
  KEY `idx_sys_logininfor_lt` (`login_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统访问记录';

-- ----------------------------
-- Records of sys_logininfor
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '权限名称',
  `path` varchar(128) DEFAULT '' COMMENT '路由地址',
  `parent_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '父级id',
  `sort` tinyint(3) unsigned NOT NULL DEFAULT '100' COMMENT '排序(数字越小越靠前)',
  `icon` varchar(128) DEFAULT '' COMMENT '菜单图标',
  `redirect_name` varchar(128) DEFAULT '' COMMENT '重定向名称',
  `is_route` smallint(3) NOT NULL DEFAULT '0' COMMENT '是否是路由 0=不是1=是',
  `is_menu` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否是菜单 0不是 1是',
  `alias` varchar(128) DEFAULT '' COMMENT '别名(废弃)',
  `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示1=显示0=不显示',
  `remark` varchar(255) DEFAULT '' COMMENT '描述',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`menu_id`),
  UNIQUE KEY `idx_path` (`path`)
) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=utf8 COMMENT='商家用户权限表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (1, '权限', '/auth', 0, 11, 'icon-quanxiankuaizhuang', '/auth/user/index', 1, 1, NULL, 1, NULL, NULL, '2023-10-29 22:25:12');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (2, '管理员', '/auth/user/index', 1, 1, NULL, NULL, 1, 1, '', 1, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (3, '角色管理', '/auth/role/index', 1, 2, NULL, NULL, 1, 1, '', 1, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (4, '菜单管理', '/auth/menu/index', 1, 3, NULL, NULL, 1, 1, '', 1, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (5, '操作日志', '/auth/optlog/index', 1, 4, NULL, NULL, 1, 1, '', 1, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (6, '登录日志', '/auth/loginlog/index', 1, 5, NULL, NULL, 1, 1, '', 1, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (7, '设置', '/settings', 0, 5, 'icon-shezhixitongshezhigongnengshezhishuxing', '/setting/config/index', 1, 1, NULL, 1, NULL, '2023-07-10 10:41:52', '2023-10-29 22:25:31');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (8, '消息', '/message', 0, 4, 'icon-xiaoxi', '/pest/cat/index', 1, 1, NULL, 1, NULL, '2023-07-10 10:59:01', '2023-10-29 22:26:07');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (9, '订单', '/ruku', 0, 1, 'icon-dingdanguanli', NULL, 1, 1, NULL, 1, NULL, '2023-07-10 11:01:41', '2023-10-29 22:28:43');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (10, '用户', '/user', 0, 3, 'icon-yonghufill', '/user/user/index', 1, 1, NULL, 1, NULL, '2023-07-10 11:02:10', '2023-10-29 22:39:01');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (11, '添加角色', '/auth/role/add', 3, 1, NULL, NULL, 1, 0, NULL, 1, NULL, '2023-07-10 11:31:08', '2023-07-10 11:35:56');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (12, '编辑角色', '/auth/role/edit', 3, 2, NULL, NULL, 1, 0, NULL, 1, NULL, '2023-07-10 11:32:02', '2023-07-10 15:54:19');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (13, '删除角色', '/auth/role/delete', 3, 3, NULL, NULL, 0, 0, '', 1, NULL, '2023-07-10 11:32:30', '2023-07-10 11:32:30');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (14, '帖子', '/post', 0, 3, 'icon-quanzi-xuanzhong', NULL, 1, 1, NULL, 1, NULL, '2023-07-10 15:06:31', '2023-10-29 22:27:10');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (15, '添加管理员', '/auth/user/add', 2, 1, NULL, NULL, 0, 0, '', 1, NULL, '2023-07-10 17:36:34', '2023-07-10 17:36:34');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (16, '编辑管理员', '/auth/user/edit', 2, 2, NULL, NULL, 0, 0, '', 1, NULL, '2023-07-13 15:37:02', '2023-07-13 15:37:02');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (17, '删除管理员', '/auth/user/delete', 2, 3, NULL, NULL, 0, 0, '', 1, NULL, '2023-07-13 15:37:31', '2023-07-13 15:37:31');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (18, '获取用户信息', '/admin/sys/admin/getInfo', 2, 4, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-13 18:33:24', '2023-07-13 18:33:24');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (19, '获取权限菜单', '/admin/sys/admin/getRoleList', 2, 5, NULL, NULL, 2, 0, NULL, 0, NULL, '2023-07-14 10:01:34', '2023-07-14 10:03:26');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (20, '获取管理员列表', '/admin/sys/admin/getList', 2, 6, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-14 10:03:03', '2023-07-14 10:03:03');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (21, '添加管理员接口', '/admin/sys/admin/add', 2, 7, NULL, NULL, 2, 0, NULL, 0, NULL, '2023-07-14 10:04:35', '2023-07-14 10:04:40');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (22, '更新管理员接口', '/admin/sys/admin/update', 2, 8, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-14 10:06:04', '2023-07-14 10:06:04');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (23, '删除管理员接口', '/admin/sys/admin/delete', 2, 9, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-14 10:15:24', '2023-07-14 10:15:24');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (26, '添加菜单', '/auth/menu/add', 4, 1, NULL, NULL, 1, 0, '', 1, NULL, '2023-07-14 10:36:12', '2023-07-14 10:36:12');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (27, '添加子菜单', '/auth/menu/addchild', 4, 2, NULL, NULL, 1, 0, '', 1, NULL, '2023-07-14 10:36:41', '2023-07-14 10:36:41');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (28, '编辑菜单', '/auth/menu/edit', 4, 3, NULL, NULL, 1, 0, '', 1, NULL, '2023-07-14 10:37:09', '2023-07-14 10:37:09');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (29, '删除菜单', '/auth/menu/delete', 4, 4, NULL, NULL, 1, 0, '', 1, NULL, '2023-07-14 10:37:54', '2023-07-14 10:37:54');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (30, '菜单树接口', '/admin/sys/menu/menuList', 4, 5, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-14 10:39:33', '2023-07-14 10:39:33');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (31, '菜单详情接口', '/admin/sys/menu/detail', 4, 6, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-14 10:39:59', '2023-07-14 10:39:59');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (32, '添加菜单接口', '/admin/sys/menu/add', 4, 7, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-14 10:41:07', '2023-07-14 10:41:07');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (33, '更新菜单接口', '/admin/sys/menu/update', 4, 8, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-14 10:42:57', '2023-07-14 10:42:57');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (34, '删除菜单接口', '/admin/sys/menu/delete', 4, 9, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-14 10:43:38', '2023-07-14 10:43:38');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (43, '复制菜单', '/auth/menu/copy', 4, 3, NULL, NULL, 1, 0, '', 1, NULL, '2023-07-14 10:47:03', '2023-07-14 10:47:03');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (44, '角色列表接口', '/admin/sys/role/lists', 3, 4, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-14 10:51:52', '2023-07-14 10:51:52');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (45, '添加角色接口', '/admin/sys/role/add', 3, 5, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-14 10:52:15', '2023-07-14 10:52:15');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (46, '角色详情接口', '/admin/sys/role/detail', 3, 6, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-14 10:52:48', '2023-07-14 10:52:48');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (47, '更新角色接口', '/admin/sys/role/update', 3, 7, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-14 10:54:43', '2023-07-14 10:54:43');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (48, '删除角色接口', '/admin/sys/role/delete', 3, 8, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-14 10:55:23', '2023-07-14 10:55:23');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (49, '获取所有角色接口', '/admin/sys/role/alllists', 3, 9, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-14 16:25:36', '2023-07-14 16:25:36');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (50, '获取登录日志列表接口', '/admin/sys/login/log/lists', 6, 1, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-14 16:27:32', '2023-07-14 16:27:32');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (51, '获取操作日志接口', '/admin/sys/opt/log/lists', 5, 1, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-14 16:38:15', '2023-07-14 16:38:15');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (52, '系统配置', '/setting/config/index', 7, 1, NULL, NULL, 1, 1, '', 1, NULL, '2023-07-17 11:20:25', '2023-07-17 11:20:25');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (53, '数据字典', '/setting/dict/index', 7, 2, NULL, NULL, 1, 1, '', 1, NULL, '2023-07-17 11:20:45', '2023-07-17 11:20:45');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (54, '获取配置列表接口', '/admin/sys/config/lists', 52, 4, NULL, NULL, 2, 0, NULL, 0, NULL, '2023-07-17 21:11:41', '2023-07-17 21:28:27');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (55, '添加系统配置接口', '/admin/sys/config/add', 52, 5, NULL, NULL, 2, 0, NULL, 0, NULL, '2023-07-17 21:12:03', '2023-07-17 21:28:41');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (56, '更新系统配置接口', '/admin/sys/config/update', 52, 6, NULL, NULL, 2, 0, NULL, 0, NULL, '2023-07-17 21:15:08', '2023-07-17 21:28:53');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (60, '删除系统配置接口', '/admin/sys/config/delete', 52, 7, NULL, NULL, 2, 0, NULL, 0, NULL, '2023-07-17 21:17:09', '2023-07-17 21:29:08');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (61, '刷新系统配置接口', '/admin/sys/config/reset', 52, 8, NULL, NULL, 2, 0, NULL, 0, NULL, '2023-07-17 21:17:37', '2023-07-17 21:29:23');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (62, '添加系统配置', '/setting/config/add', 52, 1, NULL, NULL, 0, 0, NULL, 1, NULL, '2023-07-17 21:26:24', '2023-07-17 21:27:18');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (63, '编辑系统配置', '/setting/config/edit', 52, 2, NULL, NULL, 0, 0, '', 1, NULL, '2023-07-17 21:27:34', '2023-07-17 21:27:34');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (64, '删除系统配置', '/setting/config/delete', 52, 3, NULL, NULL, 0, 0, '', 1, NULL, '2023-07-17 21:28:06', '2023-07-17 21:28:06');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (65, '刷新系统配置', '/setting/config/reset', 52, 3, NULL, NULL, 0, 0, '', 1, NULL, '2023-07-17 22:43:03', '2023-07-17 22:43:03');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (66, '添加字典类型', '/setting/dict/add', 53, 1, NULL, NULL, 0, 0, '', 1, NULL, '2023-07-18 10:47:08', '2023-07-18 10:47:08');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (67, '编辑字典类型', '/setting/dict/edit', 53, 2, NULL, NULL, 0, 0, '', 1, NULL, '2023-07-18 10:47:23', '2023-07-18 10:47:23');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (68, '删除字典类型', '/setting/dict/delete', 53, 3, NULL, NULL, 0, 0, '', 1, NULL, '2023-07-18 10:48:05', '2023-07-18 10:48:05');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (69, '字典数据列表', '/setting/dict/datalist', 53, 4, NULL, NULL, 1, 0, '', 1, NULL, '2023-07-18 10:50:44', '2023-07-18 10:50:44');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (70, '字典类型列表接口', '/admin/sys/dict/type/lists', 53, 5, NULL, NULL, 2, 0, NULL, 0, NULL, '2023-07-18 10:52:27', '2023-07-18 10:57:09');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (71, '添加字典类型接口', '/admin/sys/dict/type/add', 53, 6, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-18 10:57:30', '2023-07-18 10:57:30');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (72, '更新字典类型接口', '/admin/sys/dict/type/update', 53, 7, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-18 10:57:51', '2023-07-18 10:57:51');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (73, '删除字典类型接口', '/admin/sys/dict/type/delete', 53, 8, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-18 10:58:05', '2023-07-18 10:58:05');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (74, '字典类型详情接口', '/admin/sys/dict/type/detail', 53, 9, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-18 14:48:48', '2023-07-18 14:48:48');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (75, '添加字典数据', '/setting/dictdata/add', 69, 1, NULL, NULL, 0, 0, '', 1, NULL, '2023-07-18 14:55:24', '2023-07-18 14:55:24');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (76, '编辑字典数据', '/setting/dictdata/edit', 69, 2, NULL, NULL, 0, 0, '', 1, NULL, '2023-07-18 14:55:39', '2023-07-18 14:55:39');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (77, '删除字典数据', '/setting/dictdata/delete', 69, 3, NULL, NULL, 0, 0, '', 1, NULL, '2023-07-18 14:57:49', '2023-07-18 14:57:49');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (78, '获取字典数据列表接口', '/admin/sys/dict/data/lists', 69, 4, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-18 15:05:46', '2023-07-18 15:05:46');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (79, '添加字典数据接口', '/admin/sys/dict/data/add', 69, 5, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-18 15:06:09', '2023-07-18 15:06:09');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (80, '更新字典数据接口', '/admin/sys/dict/data/update', 69, 6, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-18 15:06:31', '2023-07-18 15:06:31');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (81, '删除字典数据接口', '/admin/sys/dict/data/delete', 69, 7, NULL, NULL, 2, 0, '', 0, NULL, '2023-07-18 15:06:47', '2023-07-18 15:06:47');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (82, '虫害分类', '/pest/cat/index', 8, 1, NULL, NULL, 1, 1, NULL, 1, NULL, '2023-09-30 16:44:47', '2023-09-30 17:05:11');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (83, '虫害列表', '/pest/pest/index', 8, 2, NULL, NULL, 1, 0, '', 1, NULL, '2023-09-30 17:04:42', '2023-09-30 17:04:42');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (85, '虫害图片', '/pest/image/index', 8, 3, NULL, NULL, 1, 0, '', 1, NULL, '2023-09-30 17:05:53', '2023-09-30 17:05:53');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (86, '语言管理', '/setting/lang/index', 7, 3, NULL, NULL, 1, 1, '', 1, NULL, '2023-10-17 11:34:18', '2023-10-17 11:34:18');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (87, '添加语言', '/setting/lang/add', 86, 1, NULL, NULL, 0, 0, '', 1, NULL, '2023-10-17 11:35:06', '2023-10-17 11:35:06');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (88, '编辑语言', '/setting/lang/edit', 86, 2, NULL, NULL, 0, 0, '', 1, NULL, '2023-10-17 11:36:29', '2023-10-17 11:36:29');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (89, '删除语言', '/setting/lang/delete', 86, 3, NULL, NULL, 0, 0, '', 1, NULL, '2023-10-17 11:38:14', '2023-10-17 11:38:14');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (90, '语言列表接口', '/admin/sys/lang/lists', 86, 5, NULL, NULL, 2, 0, NULL, 0, NULL, '2023-10-17 11:39:25', '2023-10-19 20:33:30');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (91, '添加语言接口', '/admin/sys/lang/add', 86, 6, NULL, NULL, 2, 0, NULL, 0, NULL, '2023-10-17 11:39:50', '2023-10-19 20:33:55');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (92, '更新语言接口', '/admin/lang/update', 86, 7, NULL, NULL, 2, 0, NULL, 0, NULL, '2023-10-17 11:40:24', '2023-10-17 11:40:43');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (93, '删除语言接口', '/admin/sys/lang/delete', 86, 8, NULL, NULL, 2, 0, NULL, 0, NULL, '2023-10-17 11:41:01', '2023-10-19 20:34:07');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (94, '设置默认语言接口', '/admin/sys/lang/setDefault', 86, 9, NULL, NULL, 2, 0, NULL, 0, NULL, '2023-10-18 22:55:47', '2023-10-19 20:34:19');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (95, '获取所有语言接口', '/admin/sys/lang/getAll', 86, 10, NULL, NULL, 2, 0, NULL, 0, NULL, '2023-10-19 19:34:12', '2023-10-19 20:34:33');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (96, '语言翻译', '/setting/translate/index', 7, 4, NULL, NULL, 1, 1, '', 1, NULL, '2023-10-19 20:12:03', '2023-10-19 20:12:03');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (97, '添加翻译', '/setting/translate/add', 96, 1, NULL, NULL, 0, 0, '', 1, NULL, '2023-10-19 20:13:39', '2023-10-19 20:13:39');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (98, '编辑翻译', '/setting/translate/edit', 96, 2, NULL, NULL, 0, 0, '', 1, NULL, '2023-10-19 20:28:44', '2023-10-19 20:28:44');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (99, '删除翻译', '/setting/translate/delete', 96, 3, NULL, NULL, 0, 0, '', 1, NULL, '2023-10-19 20:29:31', '2023-10-19 20:29:31');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (100, '获取翻译列表接口', '/admin/sys/translate/lists', 96, 5, NULL, NULL, 2, 0, '', 0, NULL, '2023-10-19 20:33:03', '2023-10-19 20:33:03');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (101, '添加翻译接口', '/admin/sys/translate/add', 96, 6, NULL, NULL, 2, 0, '', 0, NULL, '2023-10-19 20:38:19', '2023-10-19 20:38:19');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (102, '更新翻译接口', '/admin/sys/translate/update', 96, 7, NULL, NULL, 2, 0, '', 0, NULL, '2023-10-19 20:38:46', '2023-10-19 20:38:46');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (103, '删除翻译接口', '/admin/sys/translate/delete', 96, 8, NULL, NULL, 2, 0, '', 0, NULL, '2023-10-19 20:39:01', '2023-10-19 20:39:01');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (104, '重载缓存', '/setting/lang/reloadCache', 86, 4, NULL, NULL, 0, 0, '', 1, NULL, '2023-10-19 23:09:08', '2023-10-19 23:09:08');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (105, '重载缓存接口', '/admin/sys/lang/reloadCache', 86, 11, NULL, NULL, 2, 0, '', 0, NULL, '2023-10-19 23:09:41', '2023-10-19 23:09:41');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (106, '版本控制', '/setting/appversion/index', 7, 5, NULL, NULL, 1, 1, NULL, 1, 'APP版本控制', '2023-10-20 10:36:47', '2023-10-27 22:44:18');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (107, '添加版本', '/setting/appversion/add', 106, 1, NULL, NULL, 0, 0, '', 1, NULL, '2023-10-20 10:37:29', '2023-10-20 10:37:29');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (108, '编辑版本', '/setting/appversion/edit', 106, 2, NULL, NULL, 0, 0, '', 1, NULL, '2023-10-20 10:38:00', '2023-10-20 10:38:00');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (109, '删除版本', '/setting/appversion/delete', 106, 3, NULL, NULL, 0, 0, '', 1, NULL, '2023-10-20 10:38:17', '2023-10-20 10:38:17');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (110, '获取APP版本控制列表接口', '/admin/sys/appversion/lists', 106, 4, NULL, NULL, 2, 0, '', 1, NULL, '2023-10-20 10:41:37', '2023-10-20 10:41:37');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (111, '添加APP版本控制接口', '/admin/sys/appversion/add', 106, 5, NULL, NULL, 2, 0, '', 1, NULL, '2023-10-20 10:47:23', '2023-10-20 10:47:23');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (112, '更新APP版本控制接口', '/admin/sys/appversion/update', 106, 6, NULL, NULL, 2, 0, '', 1, NULL, '2023-10-20 10:47:43', '2023-10-20 10:47:43');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (113, '删除APP版本控制接口', '/admin/sys/appversion/delete', 106, 7, NULL, NULL, 2, 0, '', 1, NULL, '2023-10-20 10:48:01', '2023-10-20 10:48:01');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (114, '上传设置', '/setting/upload/index', 7, 6, NULL, NULL, 1, 1, '', 1, '上传设置', '2023-10-28 10:59:38', '2023-10-28 10:59:38');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (115, '获取上传配置接口', '/admin/sys/config/upload', 114, 5, NULL, NULL, 2, 0, '', 0, NULL, '2023-10-28 11:12:23', '2023-10-28 11:12:23');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (116, '会员列表', '/user/user/index', 10, 1, NULL, NULL, 1, 1, '', 1, NULL, '2023-10-29 22:33:01', '2023-10-29 22:33:01');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (117, '好友关系', '/user/friend/index', 10, 2, NULL, NULL, 1, 1, '', 1, NULL, '2023-10-29 22:35:00', '2023-10-29 22:35:00');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (118, '群组列表', '/user/group/index', 10, 3, NULL, NULL, 1, 1, '', 1, NULL, '2023-10-29 22:35:25', '2023-10-29 22:35:25');
INSERT INTO `sys_menu` (`menu_id`, `name`, `path`, `parent_id`, `sort`, `icon`, `redirect_name`, `is_route`, `is_menu`, `alias`, `is_show`, `remark`, `create_time`, `update_time`) VALUES (120, '商品', '/product', 0, 2, 'icon-shangcheng-mianxing-1', NULL, 1, 1, '', 1, NULL, '2023-10-29 22:38:49', '2023-10-29 22:38:49');
COMMIT;

-- ----------------------------
-- Table structure for sys_oper_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_oper_log`;
CREATE TABLE `sys_oper_log` (
  `oper_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志主键',
  `title` varchar(50) DEFAULT '' COMMENT '模块标题',
  `business_type` int(2) DEFAULT '0' COMMENT '业务类型（0其它 1新增 2修改 3删除）',
  `method` varchar(100) DEFAULT '' COMMENT '方法名称',
  `request_method` varchar(10) DEFAULT '' COMMENT '请求方式',
  `operator_type` int(1) DEFAULT '0' COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
  `oper_name` varchar(50) DEFAULT '' COMMENT '操作人员',
  `dept_name` varchar(50) DEFAULT '' COMMENT '部门名称',
  `oper_url` varchar(255) DEFAULT '' COMMENT '请求URL',
  `oper_ip` varchar(128) DEFAULT '' COMMENT '主机地址',
  `oper_location` varchar(255) DEFAULT '' COMMENT '操作地点',
  `oper_param` varchar(2000) DEFAULT '' COMMENT '请求参数',
  `json_result` varchar(2000) DEFAULT '' COMMENT '返回参数',
  `status` int(1) DEFAULT '0' COMMENT '操作状态（0正常 1异常）',
  `error_msg` varchar(2000) DEFAULT '' COMMENT '错误消息',
  `oper_time` datetime DEFAULT NULL COMMENT '操作时间',
  `cost_time` bigint(20) DEFAULT '0' COMMENT '消耗时间',
  PRIMARY KEY (`oper_id`),
  KEY `idx_sys_oper_log_bt` (`business_type`),
  KEY `idx_sys_oper_log_s` (`status`),
  KEY `idx_sys_oper_log_ot` (`oper_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='操作日志记录';

-- ----------------------------
-- Records of sys_oper_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_opt_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_opt_log`;
CREATE TABLE `sys_opt_log` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `admin_id` int(10) NOT NULL DEFAULT '0' COMMENT '用户id',
  `title` varchar(255) DEFAULT '' COMMENT '标题',
  `url` varchar(255) DEFAULT '' COMMENT '访问url',
  `method` varchar(50) DEFAULT '' COMMENT '请求类型',
  `content` text CHARACTER SET utf8mb4 COMMENT '操作内容',
  `ip` varchar(128) DEFAULT '' COMMENT '登录ip',
  `time` bigint(20) DEFAULT '0' COMMENT '耗时',
  `create_time` datetime DEFAULT NULL COMMENT '签到时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='管理员操作记录表';

-- ----------------------------
-- Records of sys_opt_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_opt_log` (`id`, `admin_id`, `title`, `url`, `method`, `content`, `ip`, `time`, `create_time`) VALUES (1, 1, '获取登录日志列表接口', '/admin/sys/login/log/lists', 'POST', '{\"list_rows\":[\"20\"],\"page\":[\"1\"],\"userName\":[\"\"]}', '127.0.0.1', 6, '2023-10-30 15:32:55');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色id',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '角色名称',
  `sort` int(10) unsigned NOT NULL DEFAULT '100' COMMENT '排序(数字越小越靠前)',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='商家用户角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`id`, `name`, `sort`, `create_time`, `update_time`) VALUES (1, '客服', 1, '2023-07-10 15:04:41', '2023-09-29 19:19:53');
INSERT INTO `sys_role` (`id`, `name`, `sort`, `create_time`, `update_time`) VALUES (3, '测试', 1, '2023-07-10 15:42:46', '2023-10-30 15:22:29');
INSERT INTO `sys_role` (`id`, `name`, `sort`, `create_time`, `update_time`) VALUES (4, '出库员', 3, '2023-07-10 15:51:32', '2023-07-10 17:21:25');
INSERT INTO `sys_role` (`id`, `name`, `sort`, `create_time`, `update_time`) VALUES (5, '测试', 1, '2023-07-10 17:35:13', '2023-07-10 17:35:13');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `role_id` int(11) NOT NULL DEFAULT '0' COMMENT '角色id',
  `menu_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '权限id',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `role_id` (`role_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1718891124764999681 DEFAULT CHARSET=utf8 COMMENT='商家用户角色权限关系表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844475969536, 1, 9, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844522106880, 1, 10, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844538884096, 1, 14, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844559855616, 1, 8, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844580827136, 1, 7, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844597604352, 1, 52, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844610187264, 1, 62, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844626964480, 1, 63, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844643741696, 1, 64, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844660518912, 1, 65, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844673101824, 1, 54, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844685684736, 1, 55, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844698267648, 1, 56, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844710850560, 1, 60, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844727627776, 1, 61, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844740210688, 1, 53, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844756987904, 1, 66, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844769570816, 1, 67, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844786348032, 1, 68, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844798930944, 1, 69, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844811513856, 1, 75, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844824096768, 1, 76, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844840873984, 1, 77, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844853456896, 1, 78, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844870234112, 1, 79, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844882817024, 1, 80, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844895399936, 1, 81, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844907982848, 1, 70, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844920565760, 1, 71, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844937342976, 1, 72, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844949925888, 1, 73, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844962508800, 1, 74, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844975091712, 1, 1, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716844987674624, 1, 2, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845000257536, 1, 15, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845012840448, 1, 16, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845025423360, 1, 17, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845038006272, 1, 18, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845050589184, 1, 19, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845063172096, 1, 20, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845075755008, 1, 21, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845088337920, 1, 22, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845100920832, 1, 23, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845113503744, 1, 3, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845121892352, 1, 11, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845138669568, 1, 12, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845151252480, 1, 13, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845159641088, 1, 44, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845172224000, 1, 45, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845184806912, 1, 46, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845197389824, 1, 47, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845214167040, 1, 48, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845222555648, 1, 49, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845235138560, 1, 4, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845247721472, 1, 26, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845260304384, 1, 27, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845272887296, 1, 28, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845285470208, 1, 43, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845298053120, 1, 29, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845310636032, 1, 30, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845323218944, 1, 31, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845335801856, 1, 32, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845352579072, 1, 33, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845360967680, 1, 34, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845373550592, 1, 5, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845390327808, 1, 51, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845402910720, 1, 6, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1707716845419687936, 1, 50, '2023-09-29 19:19:58');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123708035072, 3, 9, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123745783808, 3, 120, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123754172416, 3, 10, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123758366720, 3, 116, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123766755328, 3, 117, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123775143936, 3, 118, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123783532544, 3, 14, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123787726848, 3, 8, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123796115456, 3, 82, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123800309760, 3, 83, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123808698368, 3, 85, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123812892672, 3, 53, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123821281280, 3, 66, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123829669888, 3, 67, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123833864192, 3, 68, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123842252800, 3, 69, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123846447104, 3, 75, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123854835712, 3, 76, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123859030016, 3, 77, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123867418624, 3, 78, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123871612928, 3, 79, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123880001536, 3, 80, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123884195840, 3, 81, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123892584448, 3, 70, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123900973056, 3, 71, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123905167360, 3, 72, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123913555968, 3, 73, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123921944576, 3, 74, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123930333184, 3, 86, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123938721792, 3, 87, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123942916096, 3, 88, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123951304704, 3, 89, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123959693312, 3, 104, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123968081920, 3, 90, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123976470528, 3, 91, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123984859136, 3, 92, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891123993247744, 3, 93, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124001636352, 3, 94, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124010024960, 3, 95, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124022607872, 3, 105, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124035190784, 3, 96, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124043579392, 3, 97, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124051968000, 3, 98, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124060356608, 3, 99, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124064550912, 3, 100, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124072939520, 3, 101, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124081328128, 3, 102, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124085522432, 3, 103, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124093911040, 3, 106, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124102299648, 3, 107, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124110688256, 3, 108, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124114882560, 3, 109, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124119076864, 3, 110, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124127465472, 3, 111, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124135854080, 3, 112, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124144242688, 3, 113, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124148436992, 3, 114, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124156825600, 3, 115, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124161019904, 3, 1, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124169408512, 3, 2, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124173602816, 3, 15, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124181991424, 3, 16, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124186185728, 3, 17, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124194574336, 3, 18, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124198768640, 3, 19, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124207157248, 3, 20, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124211351552, 3, 21, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124219740160, 3, 22, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124223934464, 3, 23, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124232323072, 3, 3, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124240711680, 3, 11, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124249100288, 3, 12, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124257488896, 3, 13, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124265877504, 3, 44, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124274266112, 3, 45, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124358152192, 3, 46, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124366540800, 3, 47, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124374929408, 3, 48, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124379123712, 3, 49, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124387512320, 3, 4, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124391706624, 3, 26, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124400095232, 3, 27, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124408483840, 3, 28, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124421066752, 3, 43, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124437843968, 3, 29, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124450426880, 3, 30, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124467204096, 3, 31, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124517535744, 3, 32, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124555284480, 3, 33, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124689502208, 3, 34, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124702085120, 3, 5, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124714668032, 3, 51, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124752416768, 3, 6, '2023-10-30 15:22:34');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_time`) VALUES (1718891124764999680, 3, 50, '2023-10-30 15:22:34');
COMMIT;

-- ----------------------------
-- Table structure for sys_translate
-- ----------------------------
DROP TABLE IF EXISTS `sys_translate`;
CREATE TABLE `sys_translate` (
  `translate_id` int(11) NOT NULL AUTO_INCREMENT,
  `translate_key` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '翻译key',
  `remark` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '备注',
  `create_time` datetime(3) DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(3) DEFAULT NULL COMMENT '更新时间',
  `zh` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '中文简体',
  `en` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT 'English',
  `zhhant` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '中文繁体',
  PRIMARY KEY (`translate_id`),
  UNIQUE KEY `translate_key_idx` (`translate_key`) USING BTREE COMMENT 'key唯一'
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='语言翻译';

-- ----------------------------
-- Records of sys_translate
-- ----------------------------
BEGIN;
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (2, '首页', '首页', '2023-10-19 22:34:19.453', '2023-10-19 22:34:19.453', '首页', 'Home', '首页');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (3, '通讯录', '通讯录', '2023-10-19 22:36:34.919', '2023-10-19 22:36:34.919', '通讯录', 'Contacts', '通讯录');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (4, '我的', '我的', '2023-10-19 22:38:48.624', '2023-10-19 22:38:48.624', '我的', 'Me', '我的');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (5, '发现', '发现', '2023-10-19 22:39:13.329', '2023-10-19 22:39:36.979', '发现', 'Find', '发现');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (6, '刷新成功', '刷新成功', '2023-10-20 00:02:52.876', '2023-10-20 00:02:52.876', '刷新成功', 'refresh success', '刷新成功');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (7, '确定', '确定', '2023-10-20 09:04:40.220', '2023-10-20 09:04:40.220', '确定', 'Confirm', '确定');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (8, '请输入正确的邮箱', '请输入正确的邮箱', '2023-10-23 21:28:42.386', '2023-10-23 21:28:42.386', '请输入正确的邮箱', 'Please enter the correct email address', '请输入正确的邮箱');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (9, '发送成功', '发送成功', '2023-10-23 21:31:22.977', '2023-10-23 21:31:22.977', '发送成功', 'Send successfully', '发送成功');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (10, '请输入4位的验证码', '请输入4位的验证码', '2023-10-23 21:42:50.796', '2023-10-23 21:42:50.796', '请输入4位的验证码', 'Please enter the 4-digit verification code', '请输入4位的验证码');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (11, '验证码过期', '验证码过期', '2023-10-23 21:45:35.771', '2023-10-23 21:45:35.771', '验证码过期', 'The verification code expires', '验证码过期');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (12, '验证码错误', '验证码错误', '2023-10-23 21:46:47.265', '2023-10-23 21:46:47.265', '验证码错误', 'The verification code is incorrect', '验证码错误');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (13, '登录成功', '登录成功', '2023-10-23 21:47:35.668', '2023-10-23 21:47:35.668', '登录成功', 'Login successful', '登录成功');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (14, '消息', '消息', '2023-10-24 23:45:31.142', '2023-10-24 23:45:31.142', '消息', 'Message', '消息');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (15, '设置', '设置', '2023-10-25 21:43:35.080', '2023-10-25 21:43:35.080', '设置', 'Settings', '设置');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (16, '深色模式', '深色模式', '2023-10-26 00:13:33.178', '2023-10-26 00:13:33.178', '深色模式', 'Dark Mode', '深色模式');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (17, '切换语言', '切换语言', '2023-10-26 00:14:30.156', '2023-10-26 00:14:30.156', '切换语言', 'Switch Languages', '切换语言');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (18, '清除缓存', '清除缓存', '2023-10-26 00:15:24.344', '2023-10-26 00:15:24.344', '清除缓存', 'Clear The Cache', '清除缓存');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (19, '用户协议', '用户协议', '2023-10-26 00:16:02.228', '2023-10-26 00:16:02.228', '用户协议', 'User Agreement', '用户协议');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (20, '隐私协议', '隐私协议', '2023-10-26 00:16:28.336', '2023-10-26 00:16:28.336', '隐私协议', 'Privacy Agreement', '隐私协议');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (21, '注销用户', '注销用户', '2023-10-26 00:17:35.258', '2023-10-26 00:17:35.258', '注销用户', 'Log Off The User', '注销用户');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (22, '关于我们', '关于我们', '2023-10-26 00:18:13.320', '2023-10-26 00:18:13.320', '关于我们', 'About Us', '关于我们');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (23, '退出登录', '退出登录', '2023-10-26 00:18:52.741', '2023-10-26 00:18:52.741', '退出登录', 'Sign Out', '退出登录');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (24, '亮', '亮', '2023-10-26 00:19:55.419', '2023-10-26 00:19:55.419', '亮', 'Light', '亮');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (25, '暗', '暗', '2023-10-26 00:20:09.850', '2023-10-26 00:20:09.850', '暗', 'Dark', '暗');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (26, '个人信息', '个人信息', '2023-10-26 00:25:08.417', '2023-10-26 00:26:35.528', '个人信息', 'Information', '个人信息');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (27, '收藏夹', '收藏夹', '2023-10-26 00:27:22.144', '2023-10-26 00:27:22.144', '收藏夹', 'Favorites', '收藏夹');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (28, '朋友圈', '朋友圈', '2023-10-26 00:28:02.795', '2023-10-26 00:28:02.795', '朋友圈', 'Circle', '朋友圈');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (29, '验证码登录', '验证码登录', '2023-10-26 22:20:20.840', '2023-10-26 22:20:20.840', '验证码登录', 'Verification Code To Sign In', '验证码登录');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (30, '首次登录自动注册', '首次登录自动注册', '2023-10-26 22:21:02.547', '2023-10-26 22:21:02.547', '首次登录自动注册', 'Automatic registration for the first login', '首次登录自动注册');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (31, '米聊', '米聊', '2023-10-26 22:24:01.574', '2023-10-26 22:24:01.574', '米聊', 'MiChat', '米聊');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (32, '获取验证码', '获取验证码', '2023-10-26 22:25:18.987', '2023-10-26 22:25:18.987', '获取验证码', 'Get a verification code', '获取验证码');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (33, '请输入你的邮箱', '请输入你的邮箱', '2023-10-26 22:26:06.089', '2023-10-26 22:26:06.089', '请输入你的邮箱', 'Please enter your email address', '请输入你的邮箱');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (34, '已阅读并同意', '已阅读并同意', '2023-10-26 22:27:49.846', '2023-10-26 22:27:49.846', '已阅读并同意', 'Read and agree', '已阅读并同意');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (35, '和', '和', '2023-10-26 22:29:34.160', '2023-10-26 22:29:34.160', '和', 'And', '和');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (36, '输入验证码', '输入验证码', '2023-10-26 22:31:56.288', '2023-10-26 22:31:56.288', '输入验证码', 'Enter the verification code', '输入验证码');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (37, '验证码已发送', '验证码已发送', '2023-10-26 22:32:35.268', '2023-10-26 22:32:35.268', '验证码已发送', 'The verification code has been sent', '验证码已发送');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (38, '我们已给你的邮箱发送了一个4位二维码，输入验证码登录即可', '我们已给你的邮箱发送了一个4位二维码，输入验证码登录即可', '2023-10-26 22:34:05.270', '2023-10-26 22:34:05.270', '我们已给你的邮箱发送了一个4位二维码，输入验证码登录即可', 'We have sent a 4-digit code to your email, enter the verification code to log in', '我们已给你的邮箱发送了一个4位二维码，输入验证码登录即可');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (39, '为了确保本人操作，请输入验证码', '为了确保本人操作，请输入验证码', '2023-10-26 22:35:05.470', '2023-10-26 22:35:05.470', '为了确保本人操作，请输入验证码', 'To ensure that you are doing so, please enter the verification code', '为了确保本人操作，请输入验证码');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (40, '登录', '登录', '2023-10-26 22:36:17.465', '2023-10-26 22:36:17.465', '登录', 'Sign', '登录');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (41, '重新获取', '重新获取', '2023-10-26 22:39:52.442', '2023-10-26 22:39:52.442', '重新获取', 'Resend ', '重新获取');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (42, '请阅读并同意用户协议和隐私协议', '请阅读并同意用户协议和隐私协议', '2023-10-26 22:41:01.364', '2023-10-26 22:41:01.364', '请阅读并同意用户协议和隐私协议', 'Please read and agree to the User Agreement and Privacy Agreement', '请阅读并同意用户协议和隐私协议');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (43, '正在获取验证码', '正在获取验证码', '2023-10-26 22:48:51.857', '2023-10-26 22:48:51.857', '正在获取验证码', 'Getting verification code', '正在获取验证码');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (44, '请输入验证码', '请输入验证码', '2023-10-26 22:50:00.655', '2023-10-26 22:50:00.655', '请输入验证码', 'Please enter the verification code', '请输入验证码');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (45, '登录中', '登录中', '2023-10-26 22:57:59.969', '2023-10-26 22:57:59.969', '登录中', 'Logging in', '登录中');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (46, '发现新版本', '发现新版本', '2023-10-28 00:07:45.746', '2023-10-28 00:07:45.746', '发现新版本', 'Discover the new version', '发现新版本');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (47, '当前版本', '当前版本', '2023-10-28 00:08:37.189', '2023-10-28 00:08:37.189', '当前版本', 'Current version', '当前版本');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (48, '更新内容', '更新内容', '2023-10-28 00:10:21.839', '2023-10-28 00:10:21.839', '更新内容', 'Update the content', '更新内容');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (49, '正在下载，请稍后', '正在下载，请稍后', '2023-10-28 00:10:55.243', '2023-10-28 00:10:55.243', '正在下载，请稍后', 'Downloading, please later', '正在下载，请稍后');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (50, '立即升级', '立即升级', '2023-10-28 00:11:35.020', '2023-10-28 00:11:35.020', '立即升级', 'Upgrade now', '立即升级');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (51, '上传成功', '上传成功', '2023-10-29 23:03:40.391', '2023-10-29 23:03:40.391', '上传成功', 'Upload Success', '上传成功');
INSERT INTO `sys_translate` (`translate_id`, `translate_key`, `remark`, `create_time`, `update_time`, `zh`, `en`, `zhhant`) VALUES (52, '上传失败', '上传失败', '2023-10-29 23:04:03.881', '2023-10-29 23:04:03.881', '上传失败', 'Upload Fail', '上传失败');
COMMIT;

-- ----------------------------
-- Table structure for sys_upload_file
-- ----------------------------
DROP TABLE IF EXISTS `sys_upload_file`;
CREATE TABLE `sys_upload_file` (
  `file_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '文件id',
  `storage` varchar(20) NOT NULL DEFAULT '' COMMENT '存储方式 local,minio',
  `group_id` int(11) NOT NULL DEFAULT '0' COMMENT '文件分组id',
  `file_url` varchar(255) NOT NULL DEFAULT '' COMMENT '存储域名',
  `save_name` varchar(255) DEFAULT '' COMMENT '保存路径',
  `file_name` varchar(255) NOT NULL DEFAULT '' COMMENT '文件路径',
  `file_size` int(11) NOT NULL DEFAULT '0' COMMENT '文件大小(字节)',
  `file_type` varchar(20) NOT NULL DEFAULT '' COMMENT '文件类型',
  `real_name` varchar(255) DEFAULT '' COMMENT '文件真实名',
  `extension` varchar(20) NOT NULL DEFAULT '' COMMENT '文件扩展名',
  `is_user` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否为c端用户上传',
  `is_recycle` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已回收',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '软删除',
  `md5` varchar(100) DEFAULT NULL,
  `create_time` datetime(3) NOT NULL COMMENT '创建时间',
  `update_time` datetime(3) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`file_id`),
  UNIQUE KEY `path_idx` (`file_name`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='文件库记录表';

-- ----------------------------
-- Records of sys_upload_file
-- ----------------------------
BEGIN;
INSERT INTO `sys_upload_file` (`file_id`, `storage`, `group_id`, `file_url`, `save_name`, `file_name`, `file_size`, `file_type`, `real_name`, `extension`, `is_user`, `is_recycle`, `is_delete`, `md5`, `create_time`, `update_time`) VALUES (1, 'local', 2, 'http://192.168.0.103:8078', 'image/20231029/1698549178693.png', 'total_volume.png', 28026, 'image', '', 'png', 0, 0, 0, 'b8b9cbe5b0111c4d7ead2e3313f58c44', '2023-10-29 11:12:58.712', '2023-10-29 21:59:36.454');
INSERT INTO `sys_upload_file` (`file_id`, `storage`, `group_id`, `file_url`, `save_name`, `file_name`, `file_size`, `file_type`, `real_name`, `extension`, `is_user`, `is_recycle`, `is_delete`, `md5`, `create_time`, `update_time`) VALUES (2, 'local', 2, 'http://192.168.0.103:8078', 'image/20231029/1698549342808.jpg', 'login_bg.jpg', 158591, 'image', '', 'jpg', 0, 0, 0, '0d340d91db66b977a3a40e555dd69445', '2023-10-29 11:15:42.834', '2023-10-29 21:59:36.462');
INSERT INTO `sys_upload_file` (`file_id`, `storage`, `group_id`, `file_url`, `save_name`, `file_name`, `file_size`, `file_type`, `real_name`, `extension`, `is_user`, `is_recycle`, `is_delete`, `md5`, `create_time`, `update_time`) VALUES (3, 'minio', 0, 'http://192.168.0.103:9000', 'mimc/image/null', 'total_user.png', 27344, 'image', '', 'png', 0, 0, 1, '6b38b2acd02beda726fad32ab67b0210', '2023-10-29 14:48:22.666', '2023-10-29 21:49:56.650');
INSERT INTO `sys_upload_file` (`file_id`, `storage`, `group_id`, `file_url`, `save_name`, `file_name`, `file_size`, `file_type`, `real_name`, `extension`, `is_user`, `is_recycle`, `is_delete`, `md5`, `create_time`, `update_time`) VALUES (4, 'minio', 0, 'http://192.168.0.103:9000', 'mimc/image/null', 'total_shop.png', 31365, 'image', '', 'png', 0, 0, 1, '67c9ac4b7f805dd5229df5c441eb07a2', '2023-10-29 14:55:37.756', '2023-10-29 21:49:56.652');
INSERT INTO `sys_upload_file` (`file_id`, `storage`, `group_id`, `file_url`, `save_name`, `file_name`, `file_size`, `file_type`, `real_name`, `extension`, `is_user`, `is_recycle`, `is_delete`, `md5`, `create_time`, `update_time`) VALUES (5, 'minio', 2, 'http://127.0.0.1:9000', 'mimc/image/20231029/1698568366894.png', '称重.png', 60578, 'image', '', 'png', 0, 0, 0, '498aa3a6ec31f27a9f2801b8d0534cb7', '2023-10-29 16:32:46.913', '2023-10-29 21:59:36.464');
INSERT INTO `sys_upload_file` (`file_id`, `storage`, `group_id`, `file_url`, `save_name`, `file_name`, `file_size`, `file_type`, `real_name`, `extension`, `is_user`, `is_recycle`, `is_delete`, `md5`, `create_time`, `update_time`) VALUES (6, 'minio', 0, 'http://127.0.0.1:9000', 'mimc/image/20231029/1698588003142.png', '聊天 (1).png', 20424, 'image', '', 'png', 0, 0, 0, 'd8fbcd44c9bf323ac5ed5d99d1bcb783', '2023-10-29 22:00:03.165', '2023-10-29 22:00:03.165');
INSERT INTO `sys_upload_file` (`file_id`, `storage`, `group_id`, `file_url`, `save_name`, `file_name`, `file_size`, `file_type`, `real_name`, `extension`, `is_user`, `is_recycle`, `is_delete`, `md5`, `create_time`, `update_time`) VALUES (7, 'minio', 0, 'http://127.0.0.1:9000', 'mimc/image/20231029/1698588032846.png', '聊天 (2).png', 20496, 'image', '', 'png', 0, 0, 0, '04ed341b37aa5ac93ce6fcb39c9ef274', '2023-10-29 22:00:32.852', '2023-10-29 22:00:32.852');
INSERT INTO `sys_upload_file` (`file_id`, `storage`, `group_id`, `file_url`, `save_name`, `file_name`, `file_size`, `file_type`, `real_name`, `extension`, `is_user`, `is_recycle`, `is_delete`, `md5`, `create_time`, `update_time`) VALUES (8, 'local', 2, 'http://192.168.0.103:8078', 'image/20231029/1698588355925.png', '通讯录.png', 16082, 'image', '', 'png', 0, 0, 0, '58465b31fb081bedca92214a5bbb337f', '2023-10-29 22:05:55.953', '2023-10-29 22:05:55.953');
INSERT INTO `sys_upload_file` (`file_id`, `storage`, `group_id`, `file_url`, `save_name`, `file_name`, `file_size`, `file_type`, `real_name`, `extension`, `is_user`, `is_recycle`, `is_delete`, `md5`, `create_time`, `update_time`) VALUES (9, 'local', 2, 'http://192.168.0.103:8078', 'image/20231029/1698588365801.png', '通讯录(2).png', 16067, 'image', '', 'png', 0, 0, 0, 'fe5aeec45f30c3ce09a351cb6193566a', '2023-10-29 22:06:05.802', '2023-10-29 22:06:05.802');
COMMIT;

-- ----------------------------
-- Table structure for sys_upload_group
-- ----------------------------
DROP TABLE IF EXISTS `sys_upload_group`;
CREATE TABLE `sys_upload_group` (
  `group_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '分类id',
  `group_type` varchar(10) NOT NULL DEFAULT '' COMMENT '文件类型',
  `group_name` varchar(30) NOT NULL DEFAULT '' COMMENT '分类名称',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '分类排序(数字越小越靠前)',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
  `create_time` datetime(3) NOT NULL COMMENT '创建时间',
  `update_time` datetime(3) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`group_id`),
  KEY `type_index` (`group_type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='文件库分组记录表';

-- ----------------------------
-- Records of sys_upload_group
-- ----------------------------
BEGIN;
INSERT INTO `sys_upload_group` (`group_id`, `group_type`, `group_name`, `sort`, `is_delete`, `create_time`, `update_time`) VALUES (1, 'image', '图标', 3, 1, '2023-10-29 10:10:06.553', '2023-10-29 16:43:31.769');
INSERT INTO `sys_upload_group` (`group_id`, `group_type`, `group_name`, `sort`, `is_delete`, `create_time`, `update_time`) VALUES (2, 'image', '测试', 0, 0, '2023-10-29 21:45:37.439', '2023-10-29 21:45:37.439');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` bigint(20) NOT NULL COMMENT '主键id',
  `role_id` int(11) NOT NULL DEFAULT '0' COMMENT '角色id',
  `admin_id` int(11) DEFAULT NULL,
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商家用户角色记录表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
